from django.db import models

# Create your models here.
"""
管理员
"""


class Admin(models.Model):
    username = models.CharField(verbose_name="管理员名称", max_length=32)
    password = models.CharField(verbose_name="密码", max_length=64)


class Department(models.Model):
    """部门表"""
    title = models.CharField(verbose_name='标题', max_length=32)

    def __str__(self):
        return self.title


class UserInfo(models.Model):
    """员工表"""
    name = models.CharField(verbose_name='姓名', max_length=16)
    password = models.CharField(verbose_name='密码', max_length=64)
    age = models.IntegerField(verbose_name='年龄')
    accout = models.DecimalField(verbose_name='账户余额', max_digits=10, decimal_places=2, default=0)
    # create_time = models.DateTimeField(verbose_name='入职时间')
    create_time = models.DateField(verbose_name='入职时间')
    # 无约束
    # depart_id = models.BigIntegerField(verbose_name='部门ID')

    # 有约束
    # to 与那张表关联
    # to_field 表中的那一列关联
    # 写的depart 生成的数据列 depart_id
    # 部门删除
    # 级联删除
    depart = models.ForeignKey(verbose_name="部门", to="Department", to_field='id', on_delete=models.CASCADE)
    # 置空
    # depart = models.ForeignKey(to="Department", to_field='id', null=True, blank=True, on_delete=models.SET_NULL)
    gender_choices = (
        (1, '男'),
        (2, '女')
    )
    gender = models.SmallIntegerField(verbose_name='性别', choices=gender_choices)


class Phone(models.Model):
    mobile = models.CharField(verbose_name="手机号", max_length=11)
    price = models.IntegerField(verbose_name="价格")
    level_choices = (
        (1, '普通'),
        (2, '一级靓号'),
        (3, '二级靓号'),
        (4, '三级靓号'),
    )
    level = models.SmallIntegerField(verbose_name="级别", choices=level_choices, default=1)
    status_choices = (
        (1, '未占用'),
        (2, '已占用')
    )
    status = models.SmallIntegerField(verbose_name='状态', choices=status_choices)


class Order(models.Model):
    oid = models.CharField(verbose_name='订单号', max_length=64)
    title = models.CharField(verbose_name='名称', max_length=32)
    price = models.IntegerField(verbose_name='价格')
    status_chocie=(
        (1, '未支付'),
        (2, "已支付")
    )
    status = models.SmallIntegerField(verbose_name='状态', choices=status_chocie)

